Stat_Rev tab
Use the Stat_Rev (Statistics and Revenue) tab to review and adjust current year projection amounts and next year’s budget for Statistics, Revenues, and Deductions.
NOTE: Provide comments in any red comment cells.
- Global Drivers – Summarizes the Budget Assumptions to drive initial projections for the department.
- Key Department Statistics – Includes department-specific statistics that drive the variable gross revenue, variable costs, and variable labor calculations in the workbook.
Global drivers apply the overall organization growth assumptions to the department statistics. You can make adjustments in the Mar-Jun change for CY as well as Percent (%) Adjust and Amt Adjust columns for NY Budget.
Key statistics, such as patient days by Nursing unit, are defined in the Budget Statistics driver.
If a statistic Dept/Acct combination is listed in the Budget Assumptions driver, you cannot make adjustments in the budget plan file.
- Other Non-Key Statistic – Displays other statistics captured for the department, but do not drive any other calculations in the workbook.
- Patient Revenue – Summarizes all revenue. Displays projections based on historical revenue per unit plus price increase (revenue adjustments) times volume.
- Patient Revenue Detail – Displays detailed patient revenue, for both in-patient and out-patient, by specific account.
- Other Revenue – Models the projection and budget for other operating revenue accounts, using a Fixed Revenue calc method, which uses the projected value as the starting point for budget.
You can make adjustments in the Mar-Jun change, Percent (%) Adjust, and Amt Adjust columns.
NOTE: Update and review this section for comments and monthly budget spreads.
If many plan files need to be updated to recognize a change to a different calculation method after the plan files are already created, processed, and saved, complete the following steps:
-
Open the BUDYYYY table.
-
Clear the calculation method saved to the BudSpread and BudCM columns for the specific ACCT codes that were changed.
-
Rebuild and reprocess the plan files. This logic recognizes that nothing was previously saved in the BudSpread and BudCM columns in the BUDYYYY table and defaults to the new calculation method assigned in the KHAStdLine/PhyStdLine columns in the ACCT dimension table.
Calc Methods – Stat_Rev Sheet
| Calc Method | Description |
|---|---|
| Allowance | Calculate deductions based on a percentage of gross revenue. |
| BadDebt | Calculate bad debt based on a percentage of gross revenue. |
| Detail | Zeros base revenue calculations. |
| FixedRevenue | Allows changes to the projected year as well as the budget. Usually used for other operating revenue accounts. Select the monthly spread from the dropdown list. |
|
GlobalRevenue |
Pushes revenue or deduction calculations to the budget plan file from Budget Assumptions. Users cannot change the totals or the spread in the budget plan files. Only users with administrative rights can update the calculations. |
| GlobalStatistic | Pushes statistics to the budget plan file from 03 Budget Statistic driver. Users cannot change the current year adjustments, next year's budget values, or monthly spread in the budget plan files. Only users with administrative rights to update drivers can update the budgeted statistics. |
| GlobalSum | Use this SPM to budget for an account at a percentage of the total of specific other accounts on the Stat_Rev tab within the same workbook. |
|
InputMonthly |
Month-by-month input. |
|
IP_Per_Unit |
This revenue calculation method is now an independent calculation of IP revenue by account using the historical revenue per unit. |
| IP_Payor | Calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Use this calculation method only if the GL gross revenue account structure is by payor. |
| OP_Per_Unit |
This revenue calculation method is now an independent calculation of OP revenue by account using the historical revenue per unit. |
| OP_Payor | This calculation method calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Use this calculation method only if the GL gross revenue account structure is by payor. |
| Oth_Per_Unit | This revenue calculation method is now an independent calculation of Other Patient revenue by account using the historical revenue per unit. |
| Oth_Payor | This calculation method calculates the total IP revenue, and then allocates it based on the historical percentages by payor. Use this calculation method only if the GL gross revenue account structure is by payor. |
| NoBudget | Brings in historical values into the budget plan file, but the budget for next year will be zero and cannot be changed. |
| Statistic |
Calculates projected and budget key statistics. NOTE: This statistical calculation method does not recognize and pull data from the 03 Budget Statistic Driver. |
| Statistic_Oth |
Calculates projected and budget non-key statistics based on their relationship to the key statistic. NOTE: This statistical calculation method does not recognize and pull data from the 03 Budget Statistic Driver. |
| Revenue_Stat |
Use this revenue calc method to define the statistic account from the Stat_Rev tab to use as the basis of the per unit calculation and the multiplier for the budget. For example, there my be an Other Department statistic in the OR for implant cases that drive the Revenue-Implant account. |
| Add New Detail | Zero-based expense calculations when adding a new account. Inputs are done on the Detail tab in the budget plan file. |
| Add New Fixed Revenue | Use this new revenue calc method to add a new Fixed Revenue account to the Stat_Rev tab. |
| Add New Global Statistic | Pushes statistics to the budget plan file from 03 Budget Statistic driver. Users cannot change the current year adjustments, next year's budget values, or monthly spread in the budget plan files. Only users with administrative rights to update drivers can update the budgeted statistics. |
| Add New Input Monthly |
Use this new revenue or statistical calculation method to add a new account to the Stat_Rev tab. NOTE: This statistical calculation method does not recognize or pull data from the 03 Budget Statistic Driver. |
| Add New Statistic |
Use this new statistical calculation method to add a new key statistic account to the Stat_Rev tab. NOTE: This statistical calculation method does not recognize or pull data from the 03 Budget Statistic Driver. |
| Add New Statistic_Oth |
Use this new statistical calculation method to add a new Other Statistic account to the Stat_Rev tab. NOTE: This statistical calculation method does not recognize and pull data from the 03 Budget Statistic Driver. |
Provider Version Only: Calc Methods – Stat_Rev Sheet
If your organization has purchased the Provider module, you have access to the following additional calc methods:
| Calc Method | Description |
|---|---|
| ProviderRev | Transfers Revenue calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables. |
| ProviderStat | Transfers Statistic calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables. |
| ProviderComp |
Transfers Salary calculations from the Provider tab to the Stat_Rev tab to save to the Financial Data Tables. NOTE: Provider Light Version Only: Calc Methods – Stat_Rev Sheet If your organization has purchased the Provider module, you can access the following additional calc methods if using the Provider Light.
|
